Uh oh.

Houston? We have a problem...

Error 500

Don't worry, you're not lost in space yet

Return to the homepage »

Stack Trace

  • [internal function]NewsController->v(string, string, string, string, string)
  • CORE/Cake/Controller/Controller.php line 491ReflectionMethod->invokeArgs(NewsController, array)
  • CORE/Cake/Routing/Dispatcher.php line 193Controller->invokeAction(CakeRequest)
  • CORE/Cake/Routing/Dispatcher.php line 167Dispatcher->_invoke(NewsController, CakeRequest)
  • APP/webroot/index.php line 110Dispatcher->dispatch(CakeRequest, CakeResponse)
(default) 27 queries took 104 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Settings`.`id`, `Settings`.`setting_id`, `Settings`.`value`, `Settings`.`modifiable`, `Settings`.`created`, `Settings`.`modified` FROM `bigfinish-staging`.`settings` AS `Settings` WHERE `Settings`.`setting_id` = 'metadata' LIMIT 1113
2SELECT `DiscountCode`.`id`, `DiscountCode`.`code`, `DiscountCode`.`percentage_discount`, `DiscountCode`.`fixed_discount`, `DiscountCode`.`free_delivery`, `DiscountCode`.`expiry_date`, `DiscountCode`.`order_value_threshold`, `DiscountCode`.`order_value_threshold_is_in_gbp`, `DiscountCode`.`currency`, `DiscountCode`.`applies_to_bundles`, `DiscountCode`.`added_on`, `DiscountCode`.`added_by`, `DiscountCode`.`updated_at`, `DiscountCode`.`updated_by`, `DiscountCode`.`is_active`, `DiscountCode`.`is_default`, `DiscountCode`.`applies_to_physical`, `DiscountCode`.`applies_to_digital`, `DiscountCode`.`applies_to_vinyl`, `ModifiedByUser`.`id`, `ModifiedByUser`.`username`, `ModifiedByUser`.`first_name`, `ModifiedByUser`.`last_name`, `ModifiedByUser`.`password`, `ModifiedByUser`.`last_login`, `ModifiedByUser`.`created`, `ModifiedByUser`.`modified`, `ModifiedByUser`.`is_active`, (CONCAT(`ModifiedByUser`.`first_name`, " ", `ModifiedByUser`.`last_name`)) AS `ModifiedByUser__name` FROM `bigfinish-staging`.`discount_codes` AS `DiscountCode` LEFT JOIN `bigfinish-staging`.`users` AS `ModifiedByUser` ON (`DiscountCode`.`updated_by` = `ModifiedByUser`.`id`) WHERE `code` = '10peroff50' AND expiry_date >= '2024-11-26 23:59:59' AND `DiscountCode`.`is_active` = '1' LIMIT 1113
3SELECT `Collection`.`id`, `Collection`.`label`, `Collection`.`name`, `Collection`.`collection_group_id`, `Collection`.`display_order`, `Collection`.`welcome_text`, `Collection`.`welcome_text_short`, `Collection`.`collection_image`, `Collection`.`header_image`, `Collection`.`type`, `Collection`.`is_active`, `Collection`.`created_by`, `Collection`.`updated_by`, `Collection`.`created`, `Collection`.`modified`, `Collection`.`sort_alpha`, `Collection`.`sent_to_createsend`, `DiscountCodesCollection`.`id`, `DiscountCodesCollection`.`collections_id`, `DiscountCodesCollection`.`discount_codes_id` FROM `bigfinish-staging`.`collections` AS `Collection` JOIN `bigfinish-staging`.`discount_codes_collections` AS `DiscountCodesCollection` ON (`DiscountCodesCollection`.`discount_codes_id` = 7 AND `DiscountCodesCollection`.`collections_id` = `Collection`.`id`) 004
4SELECT `Range`.`id`, `Range`.`label`, `Range`.`name`, `Range`.`sort_alpha`, `Range`.`header_image`, `Range`.`logo`, `Range`.`logo_large`, `Range`.`logo_medium`, `Range`.`logo_small`, `Range`.`default_release_image`, `Range`.`welcome_text`, `Range`.`default_range_subscription_options_id`, `Range`.`is_active`, `Range`.`main_display_order`, `Range`.`added_on`, `Range`.`added_by`, `Range`.`updated_at`, `Range`.`updated_by`, `Range`.`welcome_text_subscription`, `Range`.`welcome_text_bundle`, `Range`.`index`, `Range`.`short_text`, `Range`.`sent_to_createsend`, `Range`.`activated_at`, `DiscountCodesRange`.`id`, `DiscountCodesRange`.`ranges_id`, `DiscountCodesRange`.`discount_codes_id` FROM `bigfinish-staging`.`ranges` AS `Range` JOIN `bigfinish-staging`.`discount_codes_ranges` AS `DiscountCodesRange` ON (`DiscountCodesRange`.`discount_codes_id` = 7 AND `DiscountCodesRange`.`ranges_id` = `Range`.`id`) 10910913
5SELECT `Release`.`id`, `Release`.`label`, `Release`.`name`, `Release`.`item_type`, `Release`.`season`, `Release`.`release_number`, `Release`.`release_date`, `Release`.`writer`, `Release`.`cover`, `Release`.`cover_large`, `Release`.`cover_medium`, `Release`.`cover_medium_secondary`, `Release`.`cover_small`, `Release`.`trailer_file`, `Release`.`trailer_embargo`, `Release`.`starring`, `Release`.`cast`, `Release`.`blurb`, `Release`.`price`, `Release`.`price_us`, `Release`.`price_can`, `Release`.`price_aus`, `Release`.`price_nz`, `Release`.`price_eu`, `Release`.`preorder_price`, `Release`.`preorder_price_us`, `Release`.`preorder_price_can`, `Release`.`preorder_price_aus`, `Release`.`preorder_price_nz`, `Release`.`preorder_price_eu`, `Release`.`delivery_price`, `Release`.`delivery_price_us`, `Release`.`delivery_price_can`, `Release`.`delivery_price_aus`, `Release`.`delivery_price_nz`, `Release`.`delivery_price_eu`, `Release`.`preorder_price_digital`, `Release`.`preorder_price_digital_us`, `Release`.`preorder_price_digital_can`, `Release`.`preorder_price_digital_aus`, `Release`.`preorder_price_digital_nz`, `Release`.`preorder_price_digital_eu`, `Release`.`show_web_special_banner`, `Release`.`director`, `Release`.`music`, `Release`.`number_of_discs`, `Release`.`isbn`, `Release`.`digital_isbn`, `Release`.`recorded_dates`, `Release`.`sound_design`, `Release`.`cover_art`, `Release`.`duration`, `Release`.`production_code`, `Release`.`recorded_at`, `Release`.`behind_the_scenes_information`, `Release`.`susbcriber_special_id`, `Release`.`include_in_subscription_count`, `Release`.`is_purchasable`, `Release`.`free_access_to_downloads`, `Release`.`available_as_subscription_free_gift`, `Release`.`is_active`, `Release`.`added_on`, `Release`.`added_by`, `Release`.`updated_at`, `Release`.`updated_by`, `Release`.`quickbooks_stockcode`, `Release`.`show_as_tba`, `Release`.`ribbon_show`, `Release`.`ribbon_promote`, `Release`.`postage_matrix_id`, `Release`.`vinyl_release`, `Release`.`limited_release_count`, `Release`.`physical_release_date`, `Release`.`digital_release_date`, `Release`.`blurb_short`, `Release`.`video_url`, `Release`.`bisac_code`, `Release`.`bfp_release_index`, `Release`.`show_age_warning`, `Release`.`sort_alpha`, `Release`.`release_type`, `Release`.`activated_at`, `Release`.`verified_duration`, `Release`.`is_preorder`, `Release`.`is_preorder_digital`, `Release`.`is_in_print`, `Release`.`stock_level`, `Release`.`sent_to_createsend`, `DiscountCodesRelease`.`id`, `DiscountCodesRelease`.`releases_id`, `DiscountCodesRelease`.`discount_codes_id` FROM `bigfinish-staging`.`releases` AS `Release` JOIN `bigfinish-staging`.`discount_codes_releases` AS `DiscountCodesRelease` ON (`DiscountCodesRelease`.`discount_codes_id` = 7 AND `DiscountCodesRelease`.`releases_id` = `Release`.`id`) 004
6SELECT `DeliveryAddress`.`id`, `DeliveryAddress`.`contact_name`, `DeliveryAddress`.`address`, `DeliveryAddress`.`address_line_2`, `DeliveryAddress`.`address_line_3`, `DeliveryAddress`.`town_city`, `DeliveryAddress`.`county_state`, `DeliveryAddress`.`postcode`, `DeliveryAddress`.`country_id`, `DeliveryAddress`.`customers_id`, `DeliveryAddress`.`telephone`, `Country`.`id`, `Country`.`iso`, `Country`.`name`, `Country`.`region`, `Country`.`vat_rate`, `Country`.`in_eu` FROM `bigfinish-staging`.`delivery_addresses` AS `DeliveryAddress` LEFT JOIN `bigfinish-staging`.`country` AS `Country` ON (`DeliveryAddress`.`country_id` = `Country`.`id`) WHERE `customers_id` IS NULL ORDER BY `DeliveryAddress`.`id` DESC LIMIT 1003
7SELECT `InvoiceAddress`.`id`, `InvoiceAddress`.`contact_name`, `InvoiceAddress`.`address`, `InvoiceAddress`.`address_line_2`, `InvoiceAddress`.`address_line_3`, `InvoiceAddress`.`town_city`, `InvoiceAddress`.`county_state`, `InvoiceAddress`.`postcode`, `InvoiceAddress`.`country_id`, `InvoiceAddress`.`customers_id`, `Country`.`id`, `Country`.`iso`, `Country`.`name`, `Country`.`region`, `Country`.`vat_rate`, `Country`.`in_eu` FROM `bigfinish-staging`.`invoice_addresses` AS `InvoiceAddress` LEFT JOIN `bigfinish-staging`.`country` AS `Country` ON (`InvoiceAddress`.`country_id` = `Country`.`id`) WHERE `customers_id` IS NULL ORDER BY `InvoiceAddress`.`id` DESC LIMIT 1003
8SELECT `Currency`.`id`, `Currency`.`usd`, `Currency`.`can`, `Currency`.`aus`, `Currency`.`nz`, `Currency`.`eu`, `Currency`.`updated_at`, `Currency`.`updated_by`, `ModifiedByUser`.`id`, `ModifiedByUser`.`username`, `ModifiedByUser`.`first_name`, `ModifiedByUser`.`last_name`, `ModifiedByUser`.`password`, `ModifiedByUser`.`last_login`, `ModifiedByUser`.`created`, `ModifiedByUser`.`modified`, `ModifiedByUser`.`is_active`, (CONCAT(`ModifiedByUser`.`first_name`, " ", `ModifiedByUser`.`last_name`)) AS `ModifiedByUser__name` FROM `bigfinish-staging`.`currencies` AS `Currency` LEFT JOIN `bigfinish-staging`.`users` AS `ModifiedByUser` ON (`Currency`.`updated_by` = `ModifiedByUser`.`id`) WHERE 1 = 1 LIMIT 1114
9SELECT `PostageCap`.`cap_price` FROM `bigfinish-staging`.`postage_cap` AS `PostageCap` WHERE 1 = 1 ORDER BY `id` DESC LIMIT 1113
10SELECT `Currency`.`id`, `Currency`.`usd`, `Currency`.`can`, `Currency`.`aus`, `Currency`.`nz`, `Currency`.`eu`, `Currency`.`updated_at`, `Currency`.`updated_by` FROM `bigfinish-staging`.`currencies` AS `Currency` WHERE 1 = 1 LIMIT 1113
11SELECT `Country`.`vat_rate` FROM `bigfinish-staging`.`country` AS `Country` WHERE `iso` = 'gb' ORDER BY `Country`.`name` ASC LIMIT 1113
12SELECT `Currency`.`id`, `Currency`.`usd`, `Currency`.`can`, `Currency`.`aus`, `Currency`.`nz`, `Currency`.`eu`, `Currency`.`updated_at`, `Currency`.`updated_by`, `ModifiedByUser`.`id`, `ModifiedByUser`.`username`, `ModifiedByUser`.`first_name`, `ModifiedByUser`.`last_name`, `ModifiedByUser`.`password`, `ModifiedByUser`.`last_login`, `ModifiedByUser`.`created`, `ModifiedByUser`.`modified`, `ModifiedByUser`.`is_active`, (CONCAT(`ModifiedByUser`.`first_name`, " ", `ModifiedByUser`.`last_name`)) AS `ModifiedByUser__name` FROM `bigfinish-staging`.`currencies` AS `Currency` LEFT JOIN `bigfinish-staging`.`users` AS `ModifiedByUser` ON (`Currency`.`updated_by` = `ModifiedByUser`.`id`) WHERE 1 = 1 LIMIT 1114
13SELECT `News`.`id`, `News`.`label`, `News`.`is_podcast`, `News`.`name`, `News`.`short_form_title`, `News`.`news_date`, `News`.`image`, `News`.`image_large`, `News`.`image_medium`, `News`.`image_small`, `News`.`short_form`, `News`.`story`, `News`.`download_file`, `News`.`is_active`, `News`.`added_on`, `News`.`added_by`, `News`.`updated_at`, `News`.`updated_by`, `News`.`itunes_keywords`, `News`.`itunes_subtitle`, `News`.`itunes_duration`, `News`.`pinned`, `ModifiedByUser`.`id`, `ModifiedByUser`.`username`, `ModifiedByUser`.`first_name`, `ModifiedByUser`.`last_name`, `ModifiedByUser`.`password`, `ModifiedByUser`.`last_login`, `ModifiedByUser`.`created`, `ModifiedByUser`.`modified`, `ModifiedByUser`.`is_active`, (CONCAT(`ModifiedByUser`.`first_name`, " ", `ModifiedByUser`.`last_name`)) AS `ModifiedByUser__name` FROM `bigfinish-staging`.`news` AS `News` LEFT JOIN `bigfinish-staging`.`users` AS `ModifiedByUser` ON (`News`.`updated_by` = `ModifiedByUser`.`id`) WHERE `label` = 'img src=\"' AND `News`.`is_active` = 1 ORDER BY `News`.`pinned` DESC, `News`.`news_date` DESC, `News`.`id` DESC LIMIT 1003
14SELECT `Settings`.`id`, `Settings`.`setting_id`, `Settings`.`value`, `Settings`.`modifiable`, `Settings`.`created`, `Settings`.`modified` FROM `bigfinish-staging`.`settings` AS `Settings` WHERE `Settings`.`setting_id` = 'metadata' LIMIT 1113
15SELECT `DiscountCode`.`id`, `DiscountCode`.`code`, `DiscountCode`.`percentage_discount`, `DiscountCode`.`fixed_discount`, `DiscountCode`.`free_delivery`, `DiscountCode`.`expiry_date`, `DiscountCode`.`order_value_threshold`, `DiscountCode`.`order_value_threshold_is_in_gbp`, `DiscountCode`.`currency`, `DiscountCode`.`applies_to_bundles`, `DiscountCode`.`added_on`, `DiscountCode`.`added_by`, `DiscountCode`.`updated_at`, `DiscountCode`.`updated_by`, `DiscountCode`.`is_active`, `DiscountCode`.`is_default`, `DiscountCode`.`applies_to_physical`, `DiscountCode`.`applies_to_digital`, `DiscountCode`.`applies_to_vinyl`, `ModifiedByUser`.`id`, `ModifiedByUser`.`username`, `ModifiedByUser`.`first_name`, `ModifiedByUser`.`last_name`, `ModifiedByUser`.`password`, `ModifiedByUser`.`last_login`, `ModifiedByUser`.`created`, `ModifiedByUser`.`modified`, `ModifiedByUser`.`is_active`, (CONCAT(`ModifiedByUser`.`first_name`, " ", `ModifiedByUser`.`last_name`)) AS `ModifiedByUser__name` FROM `bigfinish-staging`.`discount_codes` AS `DiscountCode` LEFT JOIN `bigfinish-staging`.`users` AS `ModifiedByUser` ON (`DiscountCode`.`updated_by` = `ModifiedByUser`.`id`) WHERE `code` = '10peroff50' AND expiry_date >= '2024-11-26 23:59:59' AND `DiscountCode`.`is_active` = '1' LIMIT 1113
16SELECT `Collection`.`id`, `Collection`.`label`, `Collection`.`name`, `Collection`.`collection_group_id`, `Collection`.`display_order`, `Collection`.`welcome_text`, `Collection`.`welcome_text_short`, `Collection`.`collection_image`, `Collection`.`header_image`, `Collection`.`type`, `Collection`.`is_active`, `Collection`.`created_by`, `Collection`.`updated_by`, `Collection`.`created`, `Collection`.`modified`, `Collection`.`sort_alpha`, `Collection`.`sent_to_createsend`, `DiscountCodesCollection`.`id`, `DiscountCodesCollection`.`collections_id`, `DiscountCodesCollection`.`discount_codes_id` FROM `bigfinish-staging`.`collections` AS `Collection` JOIN `bigfinish-staging`.`discount_codes_collections` AS `DiscountCodesCollection` ON (`DiscountCodesCollection`.`discount_codes_id` = 7 AND `DiscountCodesCollection`.`collections_id` = `Collection`.`id`) 003
17SELECT `Range`.`id`, `Range`.`label`, `Range`.`name`, `Range`.`sort_alpha`, `Range`.`header_image`, `Range`.`logo`, `Range`.`logo_large`, `Range`.`logo_medium`, `Range`.`logo_small`, `Range`.`default_release_image`, `Range`.`welcome_text`, `Range`.`default_range_subscription_options_id`, `Range`.`is_active`, `Range`.`main_display_order`, `Range`.`added_on`, `Range`.`added_by`, `Range`.`updated_at`, `Range`.`updated_by`, `Range`.`welcome_text_subscription`, `Range`.`welcome_text_bundle`, `Range`.`index`, `Range`.`short_text`, `Range`.`sent_to_createsend`, `Range`.`activated_at`, `DiscountCodesRange`.`id`, `DiscountCodesRange`.`ranges_id`, `DiscountCodesRange`.`discount_codes_id` FROM `bigfinish-staging`.`ranges` AS `Range` JOIN `bigfinish-staging`.`discount_codes_ranges` AS `DiscountCodesRange` ON (`DiscountCodesRange`.`discount_codes_id` = 7 AND `DiscountCodesRange`.`ranges_id` = `Range`.`id`) 10910912
18SELECT `Release`.`id`, `Release`.`label`, `Release`.`name`, `Release`.`item_type`, `Release`.`season`, `Release`.`release_number`, `Release`.`release_date`, `Release`.`writer`, `Release`.`cover`, `Release`.`cover_large`, `Release`.`cover_medium`, `Release`.`cover_medium_secondary`, `Release`.`cover_small`, `Release`.`trailer_file`, `Release`.`trailer_embargo`, `Release`.`starring`, `Release`.`cast`, `Release`.`blurb`, `Release`.`price`, `Release`.`price_us`, `Release`.`price_can`, `Release`.`price_aus`, `Release`.`price_nz`, `Release`.`price_eu`, `Release`.`preorder_price`, `Release`.`preorder_price_us`, `Release`.`preorder_price_can`, `Release`.`preorder_price_aus`, `Release`.`preorder_price_nz`, `Release`.`preorder_price_eu`, `Release`.`delivery_price`, `Release`.`delivery_price_us`, `Release`.`delivery_price_can`, `Release`.`delivery_price_aus`, `Release`.`delivery_price_nz`, `Release`.`delivery_price_eu`, `Release`.`preorder_price_digital`, `Release`.`preorder_price_digital_us`, `Release`.`preorder_price_digital_can`, `Release`.`preorder_price_digital_aus`, `Release`.`preorder_price_digital_nz`, `Release`.`preorder_price_digital_eu`, `Release`.`show_web_special_banner`, `Release`.`director`, `Release`.`music`, `Release`.`number_of_discs`, `Release`.`isbn`, `Release`.`digital_isbn`, `Release`.`recorded_dates`, `Release`.`sound_design`, `Release`.`cover_art`, `Release`.`duration`, `Release`.`production_code`, `Release`.`recorded_at`, `Release`.`behind_the_scenes_information`, `Release`.`susbcriber_special_id`, `Release`.`include_in_subscription_count`, `Release`.`is_purchasable`, `Release`.`free_access_to_downloads`, `Release`.`available_as_subscription_free_gift`, `Release`.`is_active`, `Release`.`added_on`, `Release`.`added_by`, `Release`.`updated_at`, `Release`.`updated_by`, `Release`.`quickbooks_stockcode`, `Release`.`show_as_tba`, `Release`.`ribbon_show`, `Release`.`ribbon_promote`, `Release`.`postage_matrix_id`, `Release`.`vinyl_release`, `Release`.`limited_release_count`, `Release`.`physical_release_date`, `Release`.`digital_release_date`, `Release`.`blurb_short`, `Release`.`video_url`, `Release`.`bisac_code`, `Release`.`bfp_release_index`, `Release`.`show_age_warning`, `Release`.`sort_alpha`, `Release`.`release_type`, `Release`.`activated_at`, `Release`.`verified_duration`, `Release`.`is_preorder`, `Release`.`is_preorder_digital`, `Release`.`is_in_print`, `Release`.`stock_level`, `Release`.`sent_to_createsend`, `DiscountCodesRelease`.`id`, `DiscountCodesRelease`.`releases_id`, `DiscountCodesRelease`.`discount_codes_id` FROM `bigfinish-staging`.`releases` AS `Release` JOIN `bigfinish-staging`.`discount_codes_releases` AS `DiscountCodesRelease` ON (`DiscountCodesRelease`.`discount_codes_id` = 7 AND `DiscountCodesRelease`.`releases_id` = `Release`.`id`) 003
19SELECT `DeliveryAddress`.`id`, `DeliveryAddress`.`contact_name`, `DeliveryAddress`.`address`, `DeliveryAddress`.`address_line_2`, `DeliveryAddress`.`address_line_3`, `DeliveryAddress`.`town_city`, `DeliveryAddress`.`county_state`, `DeliveryAddress`.`postcode`, `DeliveryAddress`.`country_id`, `DeliveryAddress`.`customers_id`, `DeliveryAddress`.`telephone`, `Country`.`id`, `Country`.`iso`, `Country`.`name`, `Country`.`region`, `Country`.`vat_rate`, `Country`.`in_eu` FROM `bigfinish-staging`.`delivery_addresses` AS `DeliveryAddress` LEFT JOIN `bigfinish-staging`.`country` AS `Country` ON (`DeliveryAddress`.`country_id` = `Country`.`id`) WHERE `customers_id` IS NULL ORDER BY `DeliveryAddress`.`id` DESC LIMIT 1003
20SELECT `InvoiceAddress`.`id`, `InvoiceAddress`.`contact_name`, `InvoiceAddress`.`address`, `InvoiceAddress`.`address_line_2`, `InvoiceAddress`.`address_line_3`, `InvoiceAddress`.`town_city`, `InvoiceAddress`.`county_state`, `InvoiceAddress`.`postcode`, `InvoiceAddress`.`country_id`, `InvoiceAddress`.`customers_id`, `Country`.`id`, `Country`.`iso`, `Country`.`name`, `Country`.`region`, `Country`.`vat_rate`, `Country`.`in_eu` FROM `bigfinish-staging`.`invoice_addresses` AS `InvoiceAddress` LEFT JOIN `bigfinish-staging`.`country` AS `Country` ON (`InvoiceAddress`.`country_id` = `Country`.`id`) WHERE `customers_id` IS NULL ORDER BY `InvoiceAddress`.`id` DESC LIMIT 1003
21SELECT `Currency`.`id`, `Currency`.`usd`, `Currency`.`can`, `Currency`.`aus`, `Currency`.`nz`, `Currency`.`eu`, `Currency`.`updated_at`, `Currency`.`updated_by`, `ModifiedByUser`.`id`, `ModifiedByUser`.`username`, `ModifiedByUser`.`first_name`, `ModifiedByUser`.`last_name`, `ModifiedByUser`.`password`, `ModifiedByUser`.`last_login`, `ModifiedByUser`.`created`, `ModifiedByUser`.`modified`, `ModifiedByUser`.`is_active`, (CONCAT(`ModifiedByUser`.`first_name`, " ", `ModifiedByUser`.`last_name`)) AS `ModifiedByUser__name` FROM `bigfinish-staging`.`currencies` AS `Currency` LEFT JOIN `bigfinish-staging`.`users` AS `ModifiedByUser` ON (`Currency`.`updated_by` = `ModifiedByUser`.`id`) WHERE 1 = 1 LIMIT 1113
22SELECT `PostageCap`.`cap_price` FROM `bigfinish-staging`.`postage_cap` AS `PostageCap` WHERE 1 = 1 ORDER BY `id` DESC LIMIT 1113
23SELECT `Currency`.`id`, `Currency`.`usd`, `Currency`.`can`, `Currency`.`aus`, `Currency`.`nz`, `Currency`.`eu`, `Currency`.`updated_at`, `Currency`.`updated_by` FROM `bigfinish-staging`.`currencies` AS `Currency` WHERE 1 = 1 LIMIT 1113
24SELECT `Country`.`vat_rate` FROM `bigfinish-staging`.`country` AS `Country` WHERE `iso` = 'gb' ORDER BY `Country`.`name` ASC LIMIT 1113
25SELECT `Currency`.`id`, `Currency`.`usd`, `Currency`.`can`, `Currency`.`aus`, `Currency`.`nz`, `Currency`.`eu`, `Currency`.`updated_at`, `Currency`.`updated_by`, `ModifiedByUser`.`id`, `ModifiedByUser`.`username`, `ModifiedByUser`.`first_name`, `ModifiedByUser`.`last_name`, `ModifiedByUser`.`password`, `ModifiedByUser`.`last_login`, `ModifiedByUser`.`created`, `ModifiedByUser`.`modified`, `ModifiedByUser`.`is_active`, (CONCAT(`ModifiedByUser`.`first_name`, " ", `ModifiedByUser`.`last_name`)) AS `ModifiedByUser__name` FROM `bigfinish-staging`.`currencies` AS `Currency` LEFT JOIN `bigfinish-staging`.`users` AS `ModifiedByUser` ON (`Currency`.`updated_by` = `ModifiedByUser`.`id`) WHERE 1 = 1 LIMIT 1113
26SELECT `Hybrid`.`id`, `Hybrid`.`name`, `Hybrid`.`label`, `Hybrid`.`header_image`, `Hybrid`.`welcome_text`, `Hybrid`.`is_active`, `Hybrid`.`created_by`, `Hybrid`.`modified_by`, `Hybrid`.`created`, `Hybrid`.`modified`, `ModifiedByUser`.`id`, `ModifiedByUser`.`username`, `ModifiedByUser`.`first_name`, `ModifiedByUser`.`last_name`, `ModifiedByUser`.`password`, `ModifiedByUser`.`last_login`, `ModifiedByUser`.`created`, `ModifiedByUser`.`modified`, `ModifiedByUser`.`is_active`, (CONCAT(`ModifiedByUser`.`first_name`, " ", `ModifiedByUser`.`last_name`)) AS `ModifiedByUser__name` FROM `bigfinish-staging`.`hybrids` AS `Hybrid` LEFT JOIN `bigfinish-staging`.`users` AS `ModifiedByUser` ON (`Hybrid`.`modified_by` = `ModifiedByUser`.`id`) WHERE `label` = 'news/v/img%20src=%22/image/releaseimage/982/medium.jpg' LIMIT 1003
27SELECT `CodedOffer`.`id`, `CodedOffer`.`label`, `CodedOffer`.`name`, `CodedOffer`.`access_code`, `CodedOffer`.`embargo_date`, `CodedOffer`.`expiry_date`, `CodedOffer`.`header_image`, `CodedOffer`.`colour`, `CodedOffer`.`logo_colour`, `CodedOffer`.`logo`, `CodedOffer`.`logo_large`, `CodedOffer`.`logo_medium`, `CodedOffer`.`logo_small`, `CodedOffer`.`welcome_text`, `CodedOffer`.`is_active`, `CodedOffer`.`added_on`, `CodedOffer`.`added_by`, `CodedOffer`.`updated_at`, `CodedOffer`.`updated_by`, `ModifiedByUser`.`id`, `ModifiedByUser`.`username`, `ModifiedByUser`.`first_name`, `ModifiedByUser`.`last_name`, `ModifiedByUser`.`password`, `ModifiedByUser`.`last_login`, `ModifiedByUser`.`created`, `ModifiedByUser`.`modified`, `ModifiedByUser`.`is_active`, (CONCAT(`ModifiedByUser`.`first_name`, " ", `ModifiedByUser`.`last_name`)) AS `ModifiedByUser__name` FROM `bigfinish-staging`.`coded_offers` AS `CodedOffer` LEFT JOIN `bigfinish-staging`.`users` AS `ModifiedByUser` ON (`CodedOffer`.`updated_by` = `ModifiedByUser`.`id`) WHERE `label` = 'news/v/img%20src=%22/image/releaseimage/982/medium.jpg' LIMIT 1003